package com.example.sxmall.dao.mapper;

import com.example.sxmall.dao.pojo.Shoe_photos;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface Shoe_photosMapper {
    /**
     * 查看图片列表
     * @return
     */
    public List<Shoe_photos> listShoe_photos();

    /**
     * 根据ID查询图片
     * @param spid
     * @return
     */
    public Shoe_photos findShoe_photosById(@Param("spid") Integer spid);

    /**
     * 根据鞋子ID查询图像
     * @param sp_sid
     * @return
     */
    public List<Shoe_photos> findShoe_photosBySid(@Param("sp_sid") Integer sp_sid);

    /**
     * 添加
     * @param shoe_photos
     * @return
     */
    public int insertShoe_photos(@Param("shoe_photos") Shoe_photos shoe_photos);

    /**
     * 删除
     * @param spid
     * @return
     */
    public int deleteShoe_photos(@Param("spid") int spid);

    /**
     * 动态修改
     * @param shoe_photos
     * @return
     */
    public int updateShoe_photos(@Param("shoe_photos") Shoe_photos shoe_photos);
}
